package com.lb.jwitter;
import java.io.Serializable;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.NamedNativeQueries;
import javax.persistence.NamedNativeQuery;
import javax.persistence.Table;
import org.hibernate.annotations.ForeignKey;


//@NamedNativeQueries({
//	@NamedNativeQuery(
//	name = "CopyKetquaDotDKHieuChinh",
//	query = "CALL CopyKetquaDotDkHieuChinh(:dotDKHieuChinhId,:dotDKDuocHieuChinhId)",
//	resultClass = Tbl_ThongTin_HocVien.class
//	)
//}) 




@Entity
@Table (name="tbl_dkmh_ketqua")
public class Tbl_DKMH_Ketqua implements Serializable {
   private static final long serialVersionUID = -1989579066723007050L;

   private Long id;
   private Tbl_DKMH_DotDK dotDKId = null;
   private Tbl_ThongTin_HocVien hocVienId = null;
   private Tbl_ThongTin_NhomLop_MonHoc nLMHId = null;
   private String ketQua;
   private String ketQuaLyDo;
   private String maDieuChinh;
   private Date ngayDangKy;
   private Date ngayCapNhat;
   private String khoaMonHocYN;
   private Boolean xacNhanYN;
   private String tinhTrang;
   private Tbl_CanBo canBoID = null;
   private String maDieuChinh2;
   private String ketQua2;

	private String ketQuaLyDo2;
	private Integer thuTuHangDoi;
   private Date ngayCapNhatCanBo;
   
   private  Tbl_ThongTin_NhomLop_MonHoc nLMHBTId = null;

   
	@Id
   @GeneratedValue
   public Long getId() {
	    return id;
   }
   public void setId(Long id) {
	    this.id= id;
   }

   @ManyToOne(fetch=FetchType.EAGER)
   @JoinColumn(name="DotDKId")
   @ForeignKey(name="FK_tbl_DKMH_DotDK_tbl_DKMH_Ketqua")
   public Tbl_DKMH_DotDK getDotDKId() {
	    return dotDKId;
   }
   public void setDotDKId(Tbl_DKMH_DotDK dotDKId) {
	    this.dotDKId=dotDKId;
   }

   @ManyToOne(fetch=FetchType.EAGER)
   @JoinColumn(name="HocVienId")
   @ForeignKey(name="FK_tbl_ThongTin_HocVien_tbl_DKMH_Ketqua")
   public Tbl_ThongTin_HocVien getHocVienId() {
	    return hocVienId;
   }
   public void setHocVienId(Tbl_ThongTin_HocVien hocVienId) {
	    this.hocVienId=hocVienId;
   }

   @ManyToOne(fetch=FetchType.EAGER)
   @JoinColumn(name="NLMHId")
   @ForeignKey(name="FK_tbl_ThongTin_NhomLop_MonHoc_tbl_DKMH_Ketqua")
   public Tbl_ThongTin_NhomLop_MonHoc getNLMHId() {
	    return nLMHId;
   }
   public void setNLMHId(Tbl_ThongTin_NhomLop_MonHoc nLMHId) {
	    this.nLMHId=nLMHId;
   }

   @ManyToOne(fetch=FetchType.EAGER)
   @JoinColumn(name="NLMHBTId")
   @ForeignKey(name="FK_tbl_ThongTin_NhomLop_MonHoc_tbl_DKMH_Ketqua1")
   public Tbl_ThongTin_NhomLop_MonHoc getNLMHBTId() {
		return nLMHBTId;
	}
	public void setNLMHBTId(Tbl_ThongTin_NhomLop_MonHoc nLMHBTId) {
		this.nLMHBTId = nLMHBTId;
	}
	
   public String getKetQua() {
   	return ketQua;
   }
   public void setKetQua(String ketQua) {
   	this.ketQua= ketQua;
   }

   public String getKetQuaLyDo() {
   	return ketQuaLyDo;
   }
   public void setKetQuaLyDo(String ketQuaLyDo) {
   	this.ketQuaLyDo= ketQuaLyDo;
   }

   public String getMaDieuChinh() {
   	return maDieuChinh;
   }
   public void setMaDieuChinh(String maDieuChinh) {
   	this.maDieuChinh= maDieuChinh;
   }

   public Date getNgayDangKy() {
   	return ngayDangKy;
   }
   public void setNgayDangKy(Date ngayDangKy) {
   	this.ngayDangKy= ngayDangKy;
   }

   public Date getNgayCapNhat() {
   	return ngayCapNhat;
   }
   public void setNgayCapNhat(Date ngayCapNhat) {
   	this.ngayCapNhat= ngayCapNhat;
   }

   public String getKhoaMonHocYN() {
   	return khoaMonHocYN;
   }
   public void setKhoaMonHocYN(String khoaMonHocYN) {
   	this.khoaMonHocYN= khoaMonHocYN;
   }

   public Boolean getXacNhanYN() {
   	return xacNhanYN;
   }
   public void setXacNhanYN(Boolean xacNhanYN) {
   	this.xacNhanYN= xacNhanYN;
   }

   public String getTinhTrang() {
   	return tinhTrang;
   }
   public void setTinhTrang(String tinhTrang) {
   	this.tinhTrang= tinhTrang;
   }

   @ManyToOne(fetch=FetchType.EAGER)
   @JoinColumn(name="CanBoID")
   @ForeignKey(name="FK_tbl_CanBo_tbl_DKMH_Ketqua")
   public Tbl_CanBo getCanBoID() {
	    return canBoID;
   }
   public void setCanBoID(Tbl_CanBo canBoID) {
	    this.canBoID=canBoID;
   }

   public String getMaDieuChinh2() {
   	return maDieuChinh2;
   }
   public void setMaDieuChinh2(String maDieuChinh2) {
   	this.maDieuChinh2= maDieuChinh2;
   }

   public Integer getThuTuHangDoi() {
   	return thuTuHangDoi;
   }
   public void setThuTuHangDoi(Integer thuTuHangDoi) {
   	this.thuTuHangDoi= thuTuHangDoi;
   }

   public Date getNgayCapNhatCanBo() {
   	return ngayCapNhatCanBo;
   }
   public void setNgayCapNhatCanBo(Date ngayCapNhatCanBo) {
   	this.ngayCapNhatCanBo= ngayCapNhatCanBo;
   }
   
   public String getKetQua2() {
		return ketQua2;
	}
	public void setKetQua2(String ketQua2) {
		this.ketQua2 = ketQua2;
	}
	   public String getKetQuaLyDo2() {
		return ketQuaLyDo2;
	}
	public void setKetQuaLyDo2(String ketQuaLyDo2) {
		this.ketQuaLyDo2 = ketQuaLyDo2;
	}
}//endClass 

